Python vs MS Access vs Excel vs ACL (Audit Control Language)
I'm currently exploring options for data analytics software. I'm familiar with programming in VB, .net, Java, SQL statements and so on. I am not familiar with Python but in my research, I came across your video series and I'm intrigued by Python's power. I have used Excel, Access, ACL and SQL for a decade or more for data crunching, financial statement data analysis.
One of the many questions that I have on Python are like these below:
Can Python, group transactions together say with a voucher number and location code then provide a summary total after each grouped record set like in Excel?
Can Python find unmatched records as well?
Does Python have the ability to do data cleansing and normalize data through a find and replace, truncate text, remove blank spaces and so forth prior to displaying data?
The data records range from a few hundred thousand to 10s of millions of records.
I look forward to your response and forgive me ahead of time but I know nothing about Python but it has caught my attention.
Cheers
You must be logged in to post. Please login or register an account.
Python can do all of the tasks you mention. Probably better put though is that *you* can do all of those things with Python. It may or may not be the case that someone has already written the code you need to do it, so you might have to do it yourself.
-Harrison 8 years ago
You must be logged in to post. Please login or register an account.